The BYPAGENO= option specified on the PROC REPORT statement might produce incorrect page numbers.

The BYPAGENO= option might also cause the ^{thispage} ODS function to display an incorrect page value.

To circumvent the problem, run a separate PROC REPORT step for each BY variable value. The page number can be reset with the following OPTIONS statement placed prior to the PROC REPORT code:

Please see the code in the Full Code tab for an example of the circumvention.

Operating System and Release Information

options nobyline orientation=landscape;
ods escapechar='^';

proc sort data=sashelp.shoes out=sorted;
   by region;
run;

data _null_;
   set sorted;
   by region;
   if first.region then do;
      count+1;
      call symput('region'||trim(left(count)),trim(left(region)));
   end;
   call symput('count',trim(left(count)));
run;

%macro loopit;
   %do i=1 %to &count;
      options pageno=1;

      proc report data=sashelp.shoes nowd;
         by region;
         where region="&®ion&i";
         column subsidiary product stores sales inventory returns;
         define subsidiary/order;
         define product/display;
         define stores/display;
         define sales/display;
         define inventory/display;
         define returns/display;
         title f=Arial h=14pt c=black 'Product Report for the #byval1 Region';
         footnote j=center f=Arial h=8pt c=black "Page ^{thispage} of ^{lastpage}";
      run;
   %end;
%mend;

ods pdf file='c:\aaa.pdf';
%loopit
ods pdf close;